Data Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	21
Number of observations	1060708
Missing cells	32061
Missing cells (%)	0.1%
Duplicate rows	88323
Duplicate rows (%)	8.3%
Total size in memory	536.6 MiB
Average record size in memory	530.4 B

Variable types

Numeric	14
DateTime	3
Categorical	2
Text	2

Alerts

Dataset has 88323 (8.3%) duplicate rows	Duplicates
`Breadth` is highly overall correlated with `Draught` and 1 other fields	High correlation
`COG` is highly overall correlated with `TH`	High correlation
`Draught` is highly overall correlated with `Breadth` and 3 other fields	High correlation
`EndLatitude` is highly overall correlated with `EndLongitude` and 6 other fields	High correlation
`EndLongitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`EndPort` is highly overall correlated with `Draught` and 8 other fields	High correlation
`Latitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`Length` is highly overall correlated with `Breadth` and 1 other fields	High correlation
`Longitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartLatitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartLongitude` is highly overall correlated with `EndLatitude` and 6 other fields	High correlation
`StartPort` is highly overall correlated with `Draught` and 8 other fields	High correlation
`TH` is highly overall correlated with `COG`	High correlation
`shiptype` is highly overall correlated with `EndPort` and 1 other fields	High correlation
`Draught` has 16270 (1.5%) missing values	Missing
`Length` has 10924 (1.0%) zeros	Zeros
`Breadth` has 10924 (1.0%) zeros	Zeros

Reproduction

Analysis started	2025-06-05 17:23:41.970287
Analysis finished	2025-06-05 17:24:49.851740
Duration	1 minute and 7.88 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

TripID
Real number (ℝ)

Distinct	1126
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1086592.4

Minimum	5944
Maximum	2278147
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	5944
5-th percentile	50976
Q1	395842
median	1111606
Q3	1660361
95-th percentile	2183444
Maximum	2278147
Range	2272203
Interquartile range (IQR)	1264519

Descriptive statistics

Standard deviation	687531.89
Coefficient of variation (CV)	0.63274133
Kurtosis	-1.2954519
Mean	1086592.4
Median Absolute Deviation (MAD)	590935
Skewness	0.073698102
Sum	1.1525572 × 10¹²
Variance	4.727001 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
665635	5901	0.6%
1007947	5520	0.5%
665728	5073	0.5%
665659	4206	0.4%
771862	3921	0.4%
183671	3870	0.4%
665761	3732	0.4%
1008001	3729	0.4%
5944	3717	0.4%
183784	3394	0.3%
Other values (1116)	1017645	95.9%

Value	Count	Frequency (%)
5944	3717	0.4%
10257	579	0.1%
19002	41	< 0.1%
19585	1646	0.2%
23834	1241	0.1%
24805	595	0.1%
25124	659	0.1%
28257	1282	0.1%
29139	1255	0.1%
29152	1305	0.1%

Value	Count	Frequency (%)
2278147	518	< 0.1%
2278140	588	0.1%
2278125	528	< 0.1%
2278114	1148	0.1%
2278113	1148	0.1%
2278085	1566	0.1%
2278084	1566	0.1%
2278083	1566	0.1%
2278070	1482	0.1%
2278069	1482	0.1%

StartLatitude
Real number (ℝ)

High correlation

Distinct	28
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.002772

Minimum	53.33
Maximum	54.54
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	53.33
5-th percentile	53.52
Q1	53.58
median	54.36
Q3	54.36
95-th percentile	54.36
Maximum	54.54
Range	1.21
Interquartile range (IQR)	0.78

Descriptive statistics

Standard deviation	0.39536968
Coefficient of variation (CV)	0.0073212849
Kurtosis	-1.9299808
Mean	54.002772
Median Absolute Deviation (MAD)	0
Skewness	-0.2043408
Sum	57281172
Variance	0.15631718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
54.36	571220	53.9%
53.58	222955	21.0%
53.59	61008	5.8%
53.53	45805	4.3%
53.51	34010	3.2%
53.57	29724	2.8%
53.6	25943	2.4%
53.52	17521	1.7%
53.61	8363	0.8%
53.55	5686	0.5%
Other values (18)	38473	3.6%

Value	Count	Frequency (%)
53.33	3169	0.3%
53.34	2535	0.2%
53.5	1285	0.1%
53.51	34010	3.2%
53.52	17521	1.7%
53.53	45805	4.3%
53.54	1289	0.1%
53.55	5686	0.5%
53.56	5654	0.5%
53.57	29724	2.8%

Value	Count	Frequency (%)
54.54	3672	0.3%
54.49	552	0.1%
54.37	1260	0.1%
54.36	571220	53.9%
54.33	3168	0.3%
54.31	1158	0.1%
53.75	976	0.1%
53.74	530	< 0.1%
53.67	4300	0.4%
53.66	411	< 0.1%

StartLongitude
Real number (ℝ)

High correlation

Distinct	34
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.4050804

Minimum	8.14
Maximum	10.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	8.14
5-th percentile	8.5
Q1	8.52
median	10.14
Q3	10.14
95-th percentile	10.14
Maximum	10.34
Range	2.2
Interquartile range (IQR)	1.62

Descriptive statistics

Standard deviation	0.81150576
Coefficient of variation (CV)	0.086283767
Kurtosis	-1.9401815
Mean	9.4050804
Median Absolute Deviation (MAD)	0
Skewness	-0.20234872
Sum	9976044.1
Variance	0.65854161
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
10.14	543986	51.3%
8.52	194761	18.4%
8.53	104786	9.9%
8.57	60852	5.7%
8.51	40838	3.9%
10.13	24050	2.3%
8.54	15232	1.4%
8.5	12688	1.2%
8.15	10967	1.0%
8.49	9064	0.9%
Other values (24)	43484	4.1%

Value	Count	Frequency (%)
8.14	485	< 0.1%
8.15	10967	1.0%
8.16	1298	0.1%
8.19	976	0.1%
8.22	530	< 0.1%
8.36	2156	0.2%
8.37	2144	0.2%
8.38	411	< 0.1%
8.39	984	0.1%
8.4	523	< 0.1%

Value	Count	Frequency (%)
10.34	552	0.1%
10.29	3672	0.3%
10.18	3188	0.3%
10.17	2939	0.3%
10.16	1489	0.1%
10.15	1154	0.1%
10.14	543986	51.3%
10.13	24050	2.3%
8.57	60852	5.7%
8.56	3146	0.3%

StartTime
Date

Distinct	953
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Minimum	2016-01-13 06:03:00
Maximum	2017-05-26 19:44:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

EndLatitude
Real number (ℝ)

High correlation

Distinct	29
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.045262

Minimum	53.47
Maximum	54.64
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	53.47
5-th percentile	53.5
Q1	53.53
median	54.38
Q3	54.53
95-th percentile	54.54
Maximum	54.64
Range	1.17
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.47881511
Coefficient of variation (CV)	0.0088595206
Kurtosis	-1.9291169
Mean	54.045262
Median Absolute Deviation (MAD)	0.16
Skewness	-0.15909692
Sum	57326241
Variance	0.22926391
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
53.53	248414	23.4%
54.54	223218	21.0%
53.5	120692	11.4%
54.38	97636	9.2%
54.52	56917	5.4%
53.52	44887	4.2%
54.53	44210	4.2%
54.44	42625	4.0%
53.54	37792	3.6%
54.43	30822	2.9%
Other values (19)	113495	10.7%

Value	Count	Frequency (%)
53.47	1291	0.1%
53.48	677	0.1%
53.49	10546	1.0%
53.5	120692	11.4%
53.51	10832	1.0%
53.52	44887	4.2%
53.53	248414	23.4%
53.54	37792	3.6%
53.56	678	0.1%
53.61	2018	0.2%

Value	Count	Frequency (%)
54.64	1646	0.2%
54.59	740	0.1%
54.54	223218	21.0%
54.53	44210	4.2%
54.52	56917	5.4%
54.51	5176	0.5%
54.5	522	< 0.1%
54.47	1282	0.1%
54.46	7698	0.7%
54.45	8806	0.8%

EndLongitude
Real number (ℝ)

High correlation

Distinct	47
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.668992

Minimum	9.5
Maximum	18.92
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	9.5
5-th percentile	9.9
Q1	9.92
median	18.5
Q3	18.6
95-th percentile	18.71
Maximum	18.92
Range	9.42
Interquartile range (IQR)	8.68

Descriptive statistics

Standard deviation	4.3208528
Coefficient of variation (CV)	0.2945569
Kurtosis	-1.9620247
Mean	14.668992
Median Absolute Deviation (MAD)	0.21
Skewness	-0.19134138
Sum	15559517
Variance	18.669769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=47)

Value	Count	Frequency (%)
9.91	125320	11.8%
18.51	120016	11.3%
18.5	103202	9.7%
9.93	88646	8.4%
9.9	76211	7.2%
9.95	72994	6.9%
18.66	49594	4.7%
18.65	49227	4.6%
18.67	38212	3.6%
18.71	35136	3.3%
Other values (37)	302150	28.5%

Value	Count	Frequency (%)
9.5	1190	0.1%
9.51	661	0.1%
9.54	1196	0.1%
9.55	178	< 0.1%
9.56	644	0.1%
9.73	678	0.1%
9.82	27618	2.6%
9.83	6963	0.7%
9.88	1222	0.1%
9.9	76211	7.2%

Value	Count	Frequency (%)
18.92	1646	0.2%
18.88	740	0.1%
18.83	9886	0.9%
18.82	18777	1.8%
18.81	4884	0.5%
18.75	1501	0.1%
18.72	3778	0.4%
18.71	35136	3.3%
18.7	7901	0.7%
18.68	3372	0.3%

EndTime
Date

Distinct	943
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	8.1 MiB

Minimum	2016-01-13 14:36:00
Maximum	2017-05-27 22:11:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

StartPort
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	64.9 MiB

KIEL	581029
BREMERHAVEN	479678
GDYNIA	1

Length

Max length	11
Median length	4
Mean length	7.1655724
Min length	4

Characters and Unicode

Total characters	7600580
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	BREMERHAVEN
2nd row	BREMERHAVEN
3rd row	BREMERHAVEN
4th row	BREMERHAVEN
5th row	BREMERHAVEN

Common Values

Value	Count	Frequency (%)
KIEL	581029	54.8%
BREMERHAVEN	479678	45.2%
GDYNIA	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
kiel	581029	54.8%
bremerhaven	479678	45.2%
gdynia	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
E	2020063	26.6%
R	959356	12.6%
I	581030	7.6%
K	581029	7.6%
L	581029	7.6%
A	479679	6.3%
N	479679	6.3%
B	479678	6.3%
H	479678	6.3%
M	479678	6.3%
Other values (4)	479681	6.3%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7600580	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
E	2020063	26.6%
R	959356	12.6%
I	581030	7.6%
K	581029	7.6%
L	581029	7.6%
A	479679	6.3%
N	479679	6.3%
B	479678	6.3%
H	479678	6.3%
M	479678	6.3%
Other values (4)	479681	6.3%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7600580	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
E	2020063	26.6%
R	959356	12.6%
I	581030	7.6%
K	581029	7.6%
L	581029	7.6%
A	479679	6.3%
N	479679	6.3%
B	479678	6.3%
H	479678	6.3%
M	479678	6.3%
Other values (4)	479681	6.3%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7600580	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
E	2020063	26.6%
R	959356	12.6%
I	581030	7.6%
K	581029	7.6%
L	581029	7.6%
A	479679	6.3%
N	479679	6.3%
B	479678	6.3%
H	479678	6.3%
M	479678	6.3%
Other values (4)	479681	6.3%

EndPort
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	64.2 MiB

GDYNIA	581029
HAMBURG	479678
486589203	1

Length

Max length	9
Median length	6
Mean length	6.4522272
Min length	6

Characters and Unicode

Total characters	6843929
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	HAMBURG
2nd row	HAMBURG
3rd row	HAMBURG
4th row	HAMBURG
5th row	HAMBURG

Common Values

Value	Count	Frequency (%)
GDYNIA	581029	54.8%
HAMBURG	479678	45.2%
486589203	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
gdynia	581029	54.8%
hamburg	479678	45.2%
486589203	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
G	1060707	15.5%
A	1060707	15.5%
D	581029	8.5%
Y	581029	8.5%
N	581029	8.5%
I	581029	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%
Other values (9)	479687	7.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	6843929	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
G	1060707	15.5%
A	1060707	15.5%
D	581029	8.5%
Y	581029	8.5%
N	581029	8.5%
I	581029	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%
Other values (9)	479687	7.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	6843929	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
G	1060707	15.5%
A	1060707	15.5%
D	581029	8.5%
Y	581029	8.5%
N	581029	8.5%
I	581029	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%
Other values (9)	479687	7.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	6843929	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
G	1060707	15.5%
A	1060707	15.5%
D	581029	8.5%
Y	581029	8.5%
N	581029	8.5%
I	581029	8.5%
H	479678	7.0%
M	479678	7.0%
B	479678	7.0%
U	479678	7.0%
Other values (9)	479687	7.0%

time
Date

Distinct	414192
Distinct (%)	39.0%
Missing	1
Missing (%)	< 0.1%
Memory size	8.1 MiB

Minimum	2016-01-13 07:03:00+01:00
Maximum	2017-05-28 00:11:00+02:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

shiptype
Real number (ℝ)

High correlation

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	72.004988

Minimum	0
Maximum	155
Zeros	7224
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	70
Q1	70
median	71
Q3	71
95-th percentile	81
Maximum	155
Range	155
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	7.036471
Coefficient of variation (CV)	0.097721994
Kurtosis	72.034492
Mean	72.004988
Median Absolute Deviation (MAD)	1
Skewness	-7.0217005
Sum	76376267
Variance	49.511924
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
71	456256	43.0%
70	355276	33.5%
79	142274	13.4%
81	65116	6.1%
72	13891	1.3%
80	11569	1.1%
0	7224	0.7%
74	3745	0.4%
73	3627	0.3%
69	1144	0.1%
Other values (2)	586	0.1%

Value	Count	Frequency (%)
0	7224	0.7%
69	1144	0.1%
70	355276	33.5%
71	456256	43.0%
72	13891	1.3%
73	3627	0.3%
74	3745	0.4%
79	142274	13.4%
80	11569	1.1%
81	65116	6.1%

Value	Count	Frequency (%)
155	1	< 0.1%
89	585	0.1%
81	65116	6.1%
80	11569	1.1%
79	142274	13.4%
74	3745	0.4%
73	3627	0.3%
72	13891	1.3%
71	456256	43.0%
70	355276	33.5%

Length
Real number (ℝ)

High correlation Zeros

Distinct	108
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	125.19246

Minimum	0
Maximum	745
Zeros	10924
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	68
Q1	88
median	134
Q3	151
95-th percentile	170
Maximum	745
Range	745
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	46.100907
Coefficient of variation (CV)	0.3682403
Kurtosis	19.6454
Mean	125.19246
Median Absolute Deviation (MAD)	32
Skewness	2.2124777
Sum	1.3279264 × 10⁸
Variance	2125.2936
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
151	115425	10.9%
134	82214	7.8%
125	68105	6.4%
88	63797	6.0%
68	62288	5.9%
155	59903	5.6%
82	48473	4.6%
168	41015	3.9%
101	39221	3.7%
79	34122	3.2%
Other values (98)	446145	42.1%

Value	Count	Frequency (%)
0	10924	1.0%
25	1	< 0.1%
45	1760	0.2%
64	250	< 0.1%
65	1362	0.1%
66	1509	0.1%
68	62288	5.9%
70	6114	0.6%
74	9904	0.9%
75	10082	1.0%

Value	Count	Frequency (%)
745	73	< 0.1%
666	163	< 0.1%
665	1	< 0.1%
663	593	0.1%
457	19	< 0.1%
399	1716	0.2%
397	1153	0.1%
396	660	0.1%
377	13	< 0.1%
300	1142	0.1%

Breadth
Real number (ℝ)

High correlation Zeros

Distinct	37
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.793313

Minimum	0
Maximum	60
Zeros	10924
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	13
median	22
Q3	24
95-th percentile	27
Maximum	60
Range	60
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.3733717
Coefficient of variation (CV)	0.32199621
Kurtosis	4.5083163
Mean	19.793313
Median Absolute Deviation (MAD)	3
Skewness	0.5233135
Sum	20994925
Variance	40.619867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=37)

Value	Count	Frequency (%)
22	156866	14.8%
12	141817	13.4%
23	141407	13.3%
24	112365	10.6%
13	96755	9.1%
18	70665	6.7%
25	68273	6.4%
26	50806	4.8%
19	38464	3.6%
11	35475	3.3%
Other values (27)	147815	13.9%

Value	Count	Frequency (%)
0	10924	1.0%
8	1760	0.2%
9	637	0.1%
9.3	1	< 0.1%
10	3753	0.4%
11	35475	3.3%
12	141817	13.4%
13	96755	9.1%
14	13143	1.2%
15	14038	1.3%

Value	Count	Frequency (%)
60	1716	0.2%
59	660	0.1%
56	1153	0.1%
48	1142	0.1%
45	85	< 0.1%
42	1071	0.1%
40	3919	0.4%
36	652	0.1%
35	564	0.1%
33	681	0.1%

Draught
Real number (ℝ)

High correlation Missing

Distinct	239
Distinct (%)	< 0.1%
Missing	16270
Missing (%)	1.5%
Infinite	0
Infinite (%)	0.0%
Mean	6.3532147

Minimum	0
Maximum	54.61
Zeros	50
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	2.8
Q1	4.3
median	6.99
Q3	8.1
95-th percentile	9.3
Maximum	54.61
Range	54.61
Interquartile range (IQR)	3.8

Descriptive statistics

Standard deviation	2.1822369
Coefficient of variation (CV)	0.34348546
Kurtosis	-0.86733974
Mean	6.3532147
Median Absolute Deviation (MAD)	1.61
Skewness	-0.23438602
Sum	6635538.9
Variance	4.7621577
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.2	62267	5.9%
2.8	56246	5.3%
8.3	30569	2.9%
7.9	21869	2.1%
8.1	20690	2.0%
7.7	20220	1.9%
7.8	20045	1.9%
8.4	19158	1.8%
3.8	16693	1.6%
8	14619	1.4%
Other values (229)	762062	71.8%
(Missing)	16270	1.5%

Value	Count	Frequency (%)
0	50	< 0.1%
0.1	637	0.1%
1.93	1771	0.2%
2.3	1612	0.2%
2.4	3660	0.3%
2.5	1373	0.1%
2.6	7279	0.7%
2.63	41	< 0.1%
2.7	1783	0.2%
2.8	56246	5.3%

Value	Count	Frequency (%)
54.61	1	< 0.1%
14	15	< 0.1%
13.23	544	0.1%
11.7	645	0.1%
11.54	1071	0.1%
11.45	551	0.1%
11.4	1223	0.1%
11.24	691	0.1%
11.1	627	0.1%
11	368	< 0.1%

Latitude
Real number (ℝ)

High correlation

Distinct	274
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54.254708

Minimum	14.63
Maximum	56.34
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	14.63
5-th percentile	53.56
Q1	53.84
median	54.42
Q3	54.64
95-th percentile	54.89
Maximum	56.34
Range	41.71
Interquartile range (IQR)	0.8

Descriptive statistics

Standard deviation	0.4627239
Coefficient of variation (CV)	0.0085287327
Kurtosis	49.525461
Mean	54.254708
Median Absolute Deviation (MAD)	0.44
Skewness	-0.6150148
Sum	57548403
Variance	0.21411341
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
53.87	36524	3.4%
53.84	25419	2.4%
53.98	24948	2.4%
54.53	24948	2.4%
54.41	21658	2.0%
53.54	21377	2.0%
53.86	21117	2.0%
53.85	20259	1.9%
53.83	20080	1.9%
53.97	19608	1.8%
Other values (264)	824770	77.8%

Value	Count	Frequency (%)
14.63	1	< 0.1%
53.33	13	< 0.1%
53.34	40	< 0.1%
53.35	29	< 0.1%
53.36	26	< 0.1%
53.37	25	< 0.1%
53.38	27	< 0.1%
53.39	26	< 0.1%
53.4	23	< 0.1%
53.41	24	< 0.1%

Value	Count	Frequency (%)
56.34	2	< 0.1%
56.33	4	< 0.1%
56.32	4	< 0.1%
56.31	3	< 0.1%
56.3	3	< 0.1%
56.29	12	< 0.1%
56.28	8	< 0.1%
56.27	5	< 0.1%
56.26	5	< 0.1%
56.25	6	< 0.1%

Longitude
Real number (ℝ)

High correlation

Distinct	1285
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.79557

Minimum	2.32
Maximum	20.66
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	2.32
5-th percentile	8.07
Q1	8.84
median	10.63
Q3	13.91
95-th percentile	18.78
Maximum	20.66
Range	18.34
Interquartile range (IQR)	5.07

Descriptive statistics

Standard deviation	3.4893558
Coefficient of variation (CV)	0.29581916
Kurtosis	-0.52728493
Mean	11.79557
Median Absolute Deviation (MAD)	2.16
Skewness	0.83164662
Sum	12511656
Variance	12.175604
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9.51	5970	0.6%
8.52	5919	0.6%
8.12	5858	0.6%
8.11	5439	0.5%
9.93	5159	0.5%
9.9	5087	0.5%
9.5	5032	0.5%
8.51	4573	0.4%
9.39	4068	0.4%
9.38	4061	0.4%
Other values (1275)	1009542	95.2%

Value	Count	Frequency (%)
2.32	1	< 0.1%
7.71	2	< 0.1%
7.72	45	< 0.1%
7.73	102	< 0.1%
7.74	99	< 0.1%
7.75	108	< 0.1%
7.76	83	< 0.1%
7.77	83	< 0.1%
7.78	81	< 0.1%
7.79	78	< 0.1%

Value	Count	Frequency (%)
20.66	1	< 0.1%
20.65	3	< 0.1%
20.64	2	< 0.1%
20.63	2	< 0.1%
20.62	6	< 0.1%
20.61	6	< 0.1%
20.6	4	< 0.1%
20.59	6	< 0.1%
20.58	6	< 0.1%
20.57	6	< 0.1%

SOG
Real number (ℝ)

Distinct	228
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12.052629

Minimum	0.2
Maximum	80.7
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0.2
5-th percentile	6.6
Q1	9.9
median	12
Q3	14.5
95-th percentile	17.4
Maximum	80.7
Range	80.5
Interquartile range (IQR)	4.6

Descriptive statistics

Standard deviation	3.4921684
Coefficient of variation (CV)	0.2897433
Kurtosis	1.0226024
Mean	12.052629
Median Absolute Deviation (MAD)	2.3
Skewness	-0.44726681
Sum	12784320
Variance	12.19524
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10.5	14605	1.4%
10.4	14338	1.4%
10.7	14081	1.3%
10.6	14073	1.3%
11.7	13702	1.3%
10.3	13450	1.3%
11.6	13441	1.3%
11	13198	1.2%
10.9	12878	1.2%
11.4	12670	1.2%
Other values (218)	924272	87.1%

Value	Count	Frequency (%)
0.2	443	< 0.1%
0.3	1912	0.2%
0.4	1615	0.2%
0.5	1232	0.1%
0.6	1093	0.1%
0.7	967	0.1%
0.8	1095	0.1%
0.9	1013	0.1%
1	915	0.1%
1.1	874	0.1%

Value	Count	Frequency (%)
80.7	1	< 0.1%
73.6	2	< 0.1%
51.2	1	< 0.1%
22.6	1	< 0.1%
22.5	1	< 0.1%
22.4	2	< 0.1%
22.3	1	< 0.1%
22.2	4	< 0.1%
22.1	4	< 0.1%
22	6	< 0.1%

COG
Real number (ℝ)

High correlation

Distinct	3602
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	126.98212

Minimum	0
Maximum	378
Zeros	210
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	45.9
Q1	82
median	100
Q3	136.3
95-th percentile	314.9
Maximum	378
Range	378
Interquartile range (IQR)	54.3

Descriptive statistics

Standard deviation	77.95504
Coefficient of variation (CV)	0.61390564
Kurtosis	1.1463034
Mean	126.98212
Median Absolute Deviation (MAD)	22.7
Skewness	1.4540593
Sum	1.3469095 × 10⁸
Variance	6076.9882
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
90	8874	0.8%
81	8420	0.8%
82	7569	0.7%
89	6461	0.6%
86	6142	0.6%
100	6036	0.6%
85	5864	0.6%
88	5757	0.5%
83	5702	0.5%
87	5569	0.5%
Other values (3592)	994314	93.7%

Value	Count	Frequency (%)
0	210	< 0.1%
0.1	580	0.1%
0.2	32	< 0.1%
0.3	26	< 0.1%
0.4	19	< 0.1%
0.5	37	< 0.1%
0.6	37	< 0.1%
0.7	35	< 0.1%
0.8	37	< 0.1%
0.9	60	< 0.1%

Value	Count	Frequency (%)
378	1	< 0.1%
360	12	< 0.1%
359.9	69	< 0.1%
359.8	41	< 0.1%
359.7	18	< 0.1%
359.6	30	< 0.1%
359.5	34	< 0.1%
359.4	24	< 0.1%
359.3	41	< 0.1%
359.2	22	< 0.1%

TH
Real number (ℝ)

High correlation

Distinct	361
Distinct (%)	< 0.1%
Missing	1
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	131.96792

Minimum	0
Maximum	511
Zeros	623
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	8.1 MiB

Quantile statistics

Minimum	0
5-th percentile	47
Q1	82
median	100
Q3	140
95-th percentile	320
Maximum	511
Range	511
Interquartile range (IQR)	58

Descriptive statistics

Standard deviation	88.949001
Coefficient of variation (CV)	0.67401988
Kurtosis	3.3333632
Mean	131.96792
Median Absolute Deviation (MAD)	23
Skewness	1.8210265
Sum	1.399793 × 10⁸
Variance	7911.9248
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	25863	2.4%
81	24895	2.3%
90	23223	2.2%
83	23083	2.2%
85	20672	1.9%
84	20368	1.9%
89	18944	1.8%
88	17458	1.6%
86	17427	1.6%
80	17292	1.6%
Other values (351)	851482	80.3%

Value	Count	Frequency (%)
0	623	0.1%
1	556	0.1%
2	479	< 0.1%
3	531	0.1%
4	319	< 0.1%
5	328	< 0.1%
6	282	< 0.1%
7	330	< 0.1%
8	304	< 0.1%
9	229	< 0.1%

Value	Count	Frequency (%)
511	12985	1.2%
359	515	< 0.1%
358	617	0.1%
357	398	< 0.1%
356	506	< 0.1%
355	594	0.1%
354	524	< 0.1%
353	331	< 0.1%
352	312	< 0.1%
351	259	< 0.1%

Destination
Text

Distinct	140
Distinct (%)	< 0.1%
Missing	5898
Missing (%)	0.6%
Memory size	64.9 MiB

Length

Max length	21
Median length	20
Mean length	7.3506698
Min length	2

Characters and Unicode

Total characters	7753560
Distinct characters	46
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	HAMBURG
2nd row	HAMBURG
3rd row	HAMBURG
4th row	HAMBURG
5th row	HAMBURG

Value	Count	Frequency (%)
hamburg	272461	25.8%
gdynia	222144	21.1%
gdansk	159967	15.2%
deham	103184	9.8%
gdynia.via.nok	35601	3.4%
de.ham	34098	3.2%
plgdn	29926	2.8%
finkenwerder	27420	2.6%
gdansk.via.nok	25973	2.5%
debrv.>.deham	21493	2.0%
Other values (120)	122543	11.6%

Most occurring characters

Value	Count	Frequency (%)
A	1077309	13.9%
G	826091	10.7%
D	808213	10.4%
N	683408	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368528	4.8%
K	350212	4.5%
E	327581	4.2%
Other values (36)	1973146	25.4%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	7753560	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
A	1077309	13.9%
G	826091	10.7%
D	808213	10.4%
N	683408	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368528	4.8%
K	350212	4.5%
E	327581	4.2%
Other values (36)	1973146	25.4%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	7753560	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
A	1077309	13.9%
G	826091	10.7%
D	808213	10.4%
N	683408	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368528	4.8%
K	350212	4.5%
E	327581	4.2%
Other values (36)	1973146	25.4%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	7753560	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
A	1077309	13.9%
G	826091	10.7%
D	808213	10.4%
N	683408	8.8%
H	460718	5.9%
M	451050	5.8%
I	427304	5.5%
R	368528	4.8%
K	350212	4.5%
E	327581	4.2%
Other values (36)	1973146	25.4%

AisSourcen
Text

Distinct	223
Distinct (%)	< 0.1%
Missing	9891
Missing (%)	0.9%
Memory size	69.4 MiB

Length

Max length	31
Median length	28
Mean length	11.994006
Min length	2

Characters and Unicode

Total characters	12603505
Distinct characters	30
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	9 ?
Unique (%)	< 0.1%

Sample

1st row	DAIS1.81b.90b.71.71a
2nd row	DAIS1.81b.90b.71.71a
3rd row	DAIS1.81b.90b.71.71a
4th row	DAIS1.81b.90b.71.71a
5th row	DAIS1.81b.90b.71.71a

Value	Count	Frequency (%)
h7001	158252	15.1%
51.71a.h7001.81b	99047	9.4%
71a.h7001.81b	85871	8.2%
71.51.71a.h7001.81b	67024	6.4%
71.71a.h7001.81b	61410	5.8%
71a.h7001	48129	4.6%
71a.h7001.67b	42889	4.1%
71.71a.h7001	40625	3.9%
71.71a.h7001.67b	33854	3.2%
71.71a.67b	33694	3.2%
Other values (213)	380022	36.2%

Most occurring characters

Value	Count	Frequency (%)
1	2823931	22.4%
7	2263856	18.0%
.	2084889	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829978	6.6%
b	682836	5.4%
8	439536	3.5%
5	287020	2.3%
6	226348	1.8%
Other values (20)	404082	3.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	12603505	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
1	2823931	22.4%
7	2263856	18.0%
.	2084889	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829978	6.6%
b	682836	5.4%
8	439536	3.5%
5	287020	2.3%
6	226348	1.8%
Other values (20)	404082	3.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	12603505	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
1	2823931	22.4%
7	2263856	18.0%
.	2084889	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829978	6.6%
b	682836	5.4%
8	439536	3.5%
5	287020	2.3%
6	226348	1.8%
Other values (20)	404082	3.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	12603505	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
1	2823931	22.4%
7	2263856	18.0%
.	2084889	16.5%
0	1722274	13.7%
H	838755	6.7%
a	829978	6.6%
b	682836	5.4%
8	439536	3.5%
5	287020	2.3%
6	226348	1.8%
Other values (20)	404082	3.2%

	Breadth	COG	Draught	EndLatitude	EndLongitude	EndPort	Latitude	Length	Longitude	SOG	StartLatitude	StartLongitude	StartPort	TH	TripID	shiptype
Breadth	1.000	0.013	0.889	0.114	-0.214	0.171	-0.044	0.942	-0.050	0.410	0.044	-0.154	0.171	0.002	-0.019	0.268
COG	0.013	1.000	-0.020	-0.299	-0.298	0.311	-0.370	-0.026	-0.154	0.010	-0.328	-0.311	0.311	0.941	0.007	0.046
Draught	0.889	-0.020	1.000	0.165	-0.110	0.711	0.040	0.900	0.031	0.413	0.155	-0.068	0.711	-0.024	0.013	0.274
EndLatitude	0.114	-0.299	0.165	1.000	0.560	0.707	0.764	0.189	0.751	-0.045	0.821	0.796	0.707	-0.290	-0.013	-0.136
EndLongitude	-0.214	-0.298	-0.110	0.560	1.000	1.000	0.737	-0.103	0.747	-0.263	0.804	0.833	1.000	-0.273	0.015	-0.017
EndPort	0.171	0.311	0.711	0.707	1.000	1.000	1.000	0.184	0.650	0.411	0.707	0.707	1.000	0.397	0.237	0.709
Latitude	-0.044	-0.370	0.040	0.764	0.737	1.000	1.000	0.049	0.781	-0.054	0.814	0.801	1.000	-0.348	-0.012	-0.096
Length	0.942	-0.026	0.900	0.189	-0.103	0.184	0.049	1.000	0.046	0.397	0.181	-0.072	0.184	-0.033	-0.046	0.223
Longitude	-0.050	-0.154	0.031	0.751	0.747	0.650	0.781	0.046	1.000	-0.223	0.815	0.802	0.650	-0.141	-0.011	-0.099
SOG	0.410	0.010	0.413	-0.045	-0.263	0.411	-0.054	0.397	-0.223	1.000	-0.115	-0.205	0.411	-0.012	-0.061	0.163
StartLatitude	0.044	-0.328	0.155	0.821	0.804	0.707	0.814	0.181	0.815	-0.115	1.000	0.812	0.707	-0.309	-0.019	-0.115
StartLongitude	-0.154	-0.311	-0.068	0.796	0.833	0.707	0.801	-0.072	0.802	-0.205	0.812	1.000	0.707	-0.292	0.005	-0.074
StartPort	0.171	0.311	0.711	0.707	1.000	1.000	1.000	0.184	0.650	0.411	0.707	0.707	1.000	0.397	0.237	0.709
TH	0.002	0.941	-0.024	-0.290	-0.273	0.397	-0.348	-0.033	-0.141	-0.012	-0.309	-0.292	0.397	1.000	0.008	0.046
TripID	-0.019	0.007	0.013	-0.013	0.015	0.237	-0.012	-0.046	-0.011	-0.061	-0.019	0.005	0.237	0.008	1.000	0.195
shiptype	0.268	0.046	0.274	-0.136	-0.017	0.709	-0.096	0.223	-0.099	0.163	-0.115	-0.074	0.709	0.046	0.195	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination	AisSourcen
0	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:07:00+01:00	71	277	42.0	11.54	53.57	8.53	0.7	331.2	143.0	HAMBURG	DAIS1.81b.90b.71.71a
1	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:10:00+01:00	71	277	42.0	11.54	53.57	8.53	1.6	315.3	117.0	HAMBURG	DAIS1.81b.90b.71.71a
2	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:10:00+01:00	71	277	42.0	11.54	53.57	8.53	2.8	322.6	100.0	HAMBURG	DAIS1.81b.90b.71.71a
3	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:12:00+01:00	71	277	42.0	11.54	53.57	8.53	2.8	286.3	74.0	HAMBURG	DAIS1.81b.90b.71.71a
4	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:16:00+01:00	71	277	42.0	11.54	53.57	8.53	4.3	333.1	333.0	HAMBURG	DAIS1.81b.90b.71.71a
5	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:17:00+01:00	71	277	42.0	11.54	53.57	8.53	5.2	334.0	333.0	HAMBURG	51.DAIS1.81b.90b.71.71a
6	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:18:00+01:00	71	277	42.0	11.54	53.57	8.53	5.7	333.0	333.0	HAMBURG	51.DAIS1.81b.90b.71.71a
7	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:19:00+01:00	71	277	42.0	11.54	53.57	8.52	6.3	333.0	333.0	HAMBURG	51.DAIS1.81b.90b.71.71a
8	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:20:00+01:00	71	277	42.0	11.54	53.58	8.52	6.8	333.0	333.0	HAMBURG	51.DAIS1.81b.90b.71.71a
9	39131	53.57	8.53	'2016-01-24 08:06'	53.53	9.9	'2016-01-24 16:44'	BREMERHAVEN	HAMBURG	2016-01-24 09:21:00+01:00	71	277	42.0	11.54	53.58	8.52	7.1	332.1	333.0	HAMBURG	51.DAIS1.81b.90b.71.71a

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination	AisSourcen
1060698	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 16:02:00+02:00	70	89	13.0	4.0	54.50	18.74	7.2	222.0	215.0	GDANSK	H7001
1060699	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 16:01:00+02:00	70	89	13.0	4.0	54.50	18.74	7.2	221.6	215.0	GDANSK	H7001
1060700	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 16:00:00+02:00	70	89	13.0	4.0	54.50	18.74	7.2	221.5	215.0	GDANSK	H7001
1060701	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:59:00+02:00	70	89	13.0	4.0	54.50	18.75	7.2	221.2	215.0	GDANSK	H7001
1060702	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:58:00+02:00	70	89	13.0	4.0	54.50	18.75	7.2	220.8	215.0	GDANSK	H7001
1060703	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:57:00+02:00	70	89	13.0	4.0	54.51	18.75	7.2	221.0	215.0	GDANSK	H7001
1060704	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:56:00+02:00	70	89	13.0	4.0	54.51	18.75	7.2	221.9	215.0	GDANSK	H7001
1060705	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:55:00+02:00	70	89	13.0	4.0	54.51	18.75	7.2	222.1	215.0	GDANSK	H7001
1060706	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:54:00+02:00	70	89	13.0	4.0	54.51	18.76	7.2	221.2	215.0	GDANSK	H7001
1060707	2204049	54.36	10.14	'2017-04-03 07:54'	54.38	18.66	'2017-04-04 15:28'	KIEL	GDYNIA	2017-04-04 15:53:00+02:00	70	89	13.0	4.0	54.51	18.76	7.2	221.0	214.0	GDANSK	H7001

Most frequently occurring

	TripID	StartLatitude	StartLongitude	StartTime	EndLatitude	EndLongitude	EndTime	StartPort	EndPort	time	shiptype	Length	Breadth	Draught	Latitude	Longitude	SOG	COG	TH	Destination	AisSourcen	# duplicates
457	5944	54.36	10.14	'2016-08-08 04:10'	54.52	18.52	'2016-08-09 12:31'	KIEL	GDYNIA	2016-08-08 13:48:00+02:00	70	82	12.0	5.3	54.47	12.24	11.4	29.5	27.0	GDYNIA.VIA.NOK	71a.H7001	6
681	5944	54.36	10.14	'2016-08-08 04:10'	54.52	18.52	'2016-08-09 12:31'	KIEL	GDYNIA	2016-08-08 17:33:00+02:00	70	82	12.0	5.3	54.69	13.31	10.8	74.4	75.0	GDYNIA.VIA.NOK	71a	6
19144	312802	53.58	8.53	'2016-07-15 19:02'	53.52	9.92	'2016-07-16 04:45'	BREMERHAVEN	HAMBURG	2016-07-16 00:31:00+02:00	71	125	22.0	7.0	53.99	8.18	10.3	90.0	91.0	HAMBURG	71a.DAIS3.H7001.81b	6
19723	312803	53.58	8.53	'2016-07-15 19:02'	53.52	9.92	'2016-07-16 04:45'	BREMERHAVEN	HAMBURG	2016-07-16 00:31:00+02:00	71	125	22.0	7.0	53.99	8.18	10.3	90.0	91.0	HAMBURG	71a.DAIS3.H7001.81b	6
20302	312804	53.58	8.53	'2016-07-15 19:02'	53.52	9.92	'2016-07-16 04:45'	BREMERHAVEN	HAMBURG	2016-07-16 00:31:00+02:00	71	125	22.0	7.0	53.99	8.18	10.3	90.0	91.0	HAMBURG	71a.DAIS3.H7001.81b	6
24139	312889	53.58	8.52	'2016-08-05 13:53'	53.53	9.91	'2016-08-05 22:23'	BREMERHAVEN	HAMBURG	2016-08-05 23:43:00+02:00	71	125	22.0	6.7	53.55	9.79	12.8	107.0	107.0	HAMBURG	71a.H7001.81b	6
24649	312890	53.58	8.52	'2016-08-05 13:53'	53.53	9.91	'2016-08-05 22:23'	BREMERHAVEN	HAMBURG	2016-08-05 23:43:00+02:00	71	125	22.0	6.7	53.55	9.79	12.8	107.0	107.0	HAMBURG	71a.H7001.81b	6
25159	312891	53.58	8.52	'2016-08-05 13:53'	53.53	9.91	'2016-08-05 22:23'	BREMERHAVEN	HAMBURG	2016-08-05 23:43:00+02:00	71	125	22.0	6.7	53.55	9.79	12.8	107.0	107.0	HAMBURG	71a.H7001.81b	6
25578	312946	53.58	8.52	'2016-08-19 14:55'	53.53	9.91	'2016-08-20 00:10'	BREMERHAVEN	HAMBURG	2016-08-19 23:15:00+02:00	71	125	22.0	6.4	53.86	9.27	12.5	115.0	116.0	DEHAM	51.71a.H7001.81b	6
26125	312947	53.58	8.52	'2016-08-19 14:55'	53.53	9.91	'2016-08-20 00:10'	BREMERHAVEN	HAMBURG	2016-08-19 23:15:00+02:00	71	125	22.0	6.4	53.86	9.27	12.5	115.0	116.0	DEHAM	51.71a.H7001.81b	6

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample

Duplicate rows

Most frequently occurring